Managing Data Service Pricing Imports & Mfg Price Sheets
| Document Version | v.1 |
|---|---|
| Document Last Updated | 4/4/18 |
| Software Version Documented | v.8.6.13 |
Task/Problem Overview
If you subscribe to a pricing service like the IDW (from IDEA) and you have a MFG that also gives you pricing spreadsheets directly with your cost, this is a way to support them both by giving preference to the MFG spreadsheet.
Pricing Profile Requirements
-
In your pricing profile(s) for the MFG that is providing spreadsheet pricing, set the TSOpt to 1
-
In the new item rules for that MFG make sure you are applying pricing profiles as stated above.
-
If you already have existing items in the system and you are implementing this policy for the first time make sure you use the pricing manager to update all of the existing profiles that apply to a TSOpt = 1.
Example Import Formulas
Cost
Dim TSO = ExistingColumns("TSOpt")
Dim StandardCost = 0
If {COST} <> "" Then
StandardCost = {COST}
ElseIf {RESALE} <> "" Then
StandardCost = {RESALE}
Else
StandardCost = 0
End If
If TSO <> 1 Then
Output = StandardCost
Else
Output = SkipUpdating()
End If
Standard Cost
If {COST} <> "" Then
Output = {COST}
ElseIf {RESALE} <> "" Then
Output = {RESALE}
Else
Output = 0
End If
List Price
If ExistingColumns("TSOpt") = 1 Then
If {LIST} <> "" Then
Output = {LIST}
Else
Output = 0
End If
Else
If {COL3} <> "" Then
Output = {COL3}
Else
Output = 0
End If
End If